package com.yida.gwj.oracle.basic.domain;

import com.mybatisflex.annotation.Column;
import com.mybatisflex.annotation.Id;
import com.mybatisflex.annotation.KeyType;
import com.mybatisflex.annotation.Table;
import lombok.Data;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.util.Date;

/***
 * @title eda
 * @description 房屋信息实体类
 * @author eda
 * @version 1.0.0
 * @create 2021/9/16 9:52
 **/
@Data
@Table(value = "JCSJ.H")
public class House {

    /**
     * 户标识码
     */
    @Id(keyType = KeyType.Auto)
    @Column(value = "HBSM")
    private Integer HBSM;

    /**
     * 丘编号
     */
    @Column(value = "QBH")
    private String QBH;

    /**
     * 自然幢标识码
     */
    @Column(value = "ZRZBSM")
    private Integer ZRZBSM;

    /**
     * 坐落标识码
     */
    @Column(value = "ZLBSM")
    private Integer ZLBSM;

    /**
     * 实际层
     */
    @Column(value = "SJC")
    private Integer SJC;

    /**
     * 名义层
     */
    @Column(value = "MYC")
    private String MYC;

    /**
     * 户号
     */
    @Column(value = "HH")
    private String HH;

    /**
     * 户型
     */
    @Column(value = "HX")
    private String HX;

    /**
     * 用途
     */
    @Column(value = "GHYT")
    private String GHYT;

    /**
     * 现房建筑面积
     */
    @Column(value = "XFJZMJ")
    private BigDecimal XFJZMJ;

    /**
     * 现房套内建筑面积
     */
    @Column(value = "XFTNJZMJ")
    private BigDecimal XFTNJZMJ;

    /**
     * 现房分摊建筑面积
     */
    @Column(value = "XFFTJZMJ")
    private BigDecimal XFFTJZMJ;

    /**
     * 现房其他建筑面积
     */
    @Column(value = "XFQTJZMJ")
    private BigDecimal XFQTJZMJ;

    /**
     * 现房分摊系数
     */
    @Column(value = "XFFTXS")
    private BigDecimal XFFTXS;

    /**
     * 期房预测建筑面积
     */
    @Column(value = "QFYCJZMJ")
    private BigDecimal QFYCJZMJ;

    /**
     * 期房套内建筑面积
     */
    @Column(value = "QFTNJZMJ")
    private BigDecimal QFTNJZMJ;

    /**
     * 期房分摊建筑面积
     */
    @Column(value = "QFFTJZMJ")
    private BigDecimal QFFTJZMJ;

    /**
     * 期房其他建筑面积
     */
    @Column(value = "QFQTJZMJ")
    private BigDecimal QFQTJZMJ;

    /**
     * 期房分摊系数
     */
    @Column(value = "QFFTXS")
    private BigDecimal QFFTXS;

    /**
     * 共有土地面积
     */
    @Column(value = "GYTDMJ")
    private BigDecimal GYTDMJ;

    /**
     * 分摊土地面积
     */
    @Column(value = "FTTDMJ")
    private BigDecimal FTTDMJ;

    /**
     * 独用土地面积
     */
    @Column(value = "DYTDMJ")
    private BigDecimal DYTDMJ;

    /**
     * 现房地下部分面积
     */
    @Column(value = "XFDXBFMJ")
    private BigDecimal XFDXBFMJ;

    /**
     * 期房地下部分面积
     */
    @Column(value = "QFDXBFMJ")
    private BigDecimal QFDXBFMJ;

    /**
     * 房产平面图编号
     */
    @Column(value = "FCPMTBH")
    private Integer FCPMTBH;

    /**
     * 是否可以交易 1是 0否
     */
    @Column(value = "FWBZ")
    private String FWBZ;

    /**
     * 房屋类型
     */
    @Column(value = "FWLX")
    private String FWLX;

    /**
     * 房屋分类
     */
    @Column(value = "FWFL")
    private String FWFL;

    /**
     * 装修水平
     */
    @Column(value = "ZXSP")
    private String ZXSP;

    /**
     * 房屋来源
     */
    @Column(value = "FWLY")
    private String FWLY;

    /**
     * 数据来源
     */
    @Column(value = "SJLY")
    private String SJLY;

    /**
     * 备注
     */
    @Column(value = "REMARK")
    private String REMARK;

    /**
     * 逻辑幢号
     */
    @Column(value = "LJZH")
    private Integer LJZH;

    /**
     * 层号
     */
    @Column(value = "CH")
    private Integer CH;

    /**
     * 房屋坐落
     */
    @Column(value = "FWZL")
    private String FWZL;

    /**
     * 建筑结构
     */
    @Column(value = "JZJG")
    private String JZJG;

    /**
     * 室号位置
     */
    @Column(value = "SHWZ")
    private Integer SHWZ;

    /**
     * 自然幢号
     */
    @Column(value = "ZRZH")
    private String ZRZH;

    /**
     * 是否有效
     */
    @Column(value = "SFYX")
    private Integer SFYX;

    /**
     * 旧标识码
     */
    @Column(value = "OLDBSM")
    private String OLDBSM;

    /**
     * 是否预售许可
     */
    @Column(value = "IS_SALE_PERMIT")
    private String IS_SALE_PERMIT;

    /**
     * 是否已认购
     */
    @Column(value = "IS_SUBSCRIBE")
    private String IS_SUBSCRIBE;

    /**
     * 是否已签约
     */
    @Column(value = "IS_CONTRACT_SIGN")
    private String IS_CONTRACT_SIGN;

    /**
     * 是否已合同登记备案
     */
    @Column(value = "IS_HOUSE_CONTRACT_REGISTER")
    private String IS_HOUSE_CONTRACT_REGISTER;

    /**
     * 是否已预购商品房预告登记
     */
    @Column(value = "IS_HOUSE_PREDICT_REGISTER")
    private String IS_HOUSE_PREDICT_REGISTER;

    /**
     * 是否已预购商品房抵押权预告登记
     */
    @Column(value = "IS_HOUSE_PREDICT_MORT_REGISTER")
    private String IS_HOUSE_PREDICT_MORT_REGISTER;

    /**
     * 是否已所有权转移预告登记
     */
    @Column(value = "IS_OWNERSHIP_TRANSFER_REGISTER")
    private String IS_OWNERSHIP_TRANSFER_REGISTER;

    /**
     * 是否抵押权预告登记
     */
    @Column(value = "IS_MORT_PREDICT_REGISTER")
    private String IS_MORT_PREDICT_REGISTER;

    /**
     * 是否总登记
     */
    @Column(value = "IS_INITIAL_REGISTER")
    private String IS_INITIAL_REGISTER;

    /**
     * 是否租赁登记
     */
    @Column(value = "IS_RENT_REGISTER")
    private String IS_RENT_REGISTER;

    /**
     * 是否限制登记
     */
    @Column(value = "IS_RESTRICT_REGISTER")
    private String IS_RESTRICT_REGISTER;

    /**
     * 是否异议登记
     */
    @Column(value = "IS_OBJECTION_REGISTER")
    private String IS_OBJECTION_REGISTER;

    /**
     * 是否地域权登记
     */
    @Column(value = "IS_BOUNDARY_REGISTER")
    private String IS_BOUNDARY_REGISTER;

    /**
     * 是否注销登记
     */
    @Column(value = "IS_LOGOUT_REGISTER")
    private String IS_LOGOUT_REGISTER;

    /**
     * 是否产权登记
     */
    @Column(value = "IS_TRANSFER_REGISTER")
    private String IS_TRANSFER_REGISTER;

    /**
     * 是否抵押登记
     */
    @Column(value = "IS_MORT_REGISTER")
    private String IS_MORT_REGISTER;

    /**
     * 是否“公告”登记
     */
    @Column(value = "IS_PUBLICATED")
    private String IS_PUBLICATED;

    /**
     * 资源创建案例编号
     */
    @Column(value = "CREATEDOCID")
    private BigInteger CREATEDOCID;

    /**
     * 产权用途
     */
    @Column(value = "CQYT")
    private Integer CQYT;

    /**
     * 预售单价
     */
    @Column(value = "YSDJ")
    private BigDecimal YSDJ;

    /**
     * 0:无;1:预标注;2:标注;-1:注销;~0~△~1~▲~2~╳~-1
     */
    @Column(value = "SALEREGISTMARK")
    private Integer SALEREGISTMARK;

    /**
     * 产权登记标注
     */
    @Column(value = "REALREGISTID")
    private Integer REALREGISTID;

    /**
     * 0:无;1:预标注;2:标注;-1:注销;
     */
    @Column(value = "REALREGISTMARK")
    private Integer REALREGISTMARK;

    /**
     * 抵押权登记标注
     */
    @Column(value = "MORTAGAGEREGISTID")
    private Integer MORTAGAGEREGISTID;

    /**
     * 0:无;1:预标注;2:标注;-1:注销;
     */
    @Column(value = "MORTAGAGEREGISTMARK")
    private Integer MORTAGAGEREGISTMARK;

    /**
     * 租赁权登记标注
     */
    @Column(value = "TENANCYREGISTID")
    private Integer TENANCYREGISTID;

    /**
     * 0:无;1:预标注;2:标注;-1:注销;
     */
    @Column(value = "TENANCYREGISTMARK")
    private Integer TENANCYREGISTMARK;

    /**
     * 限制登记标注
     */
    @Column(value = "LIMITREGISTID")
    private Integer LIMITREGISTID;

    /**
     * 0:无;1:预标注;2:标注;-1:注销;
     */
    @Column(value = "LIMITREGISTMARK")
    private Integer LIMITREGISTMARK;

    /**
     * 预告登记标注
     */
    @Column(value = "OTHERREGISTID")
    private Integer OTHERREGISTID;

    @Column(value = "OTHERREGISTMARK")
    private Integer OTHERREGISTMARK;

    /**
     * 合同备案预登记标注
     */
    @Column(value = "COMPREGISTID")
    private Integer COMPREGISTID;

    @Column(value = "COMPREGISTMARK")
    private Integer COMPREGISTMARK;

    /**
     * 区县
     */
    @Column(value = "QX")
    private String QX;

    /**
     * 街道
     */
    @Column(value = "JD")
    private String JD;

    /**
     * 预售证号
     */
    @Column(value = "YSZH")
    private String YSZH;

    /**
     * 合同编号
     */
    @Column(value = "HTBH")
    private String HTBH;

    /**
     * 产权证号
     */
    @Column(value = "REALNO")
    private String REALNO;

    /**
     * 产权人
     */
    @Column(value = "HOLDERNAME")
    private String HOLDERNAME;

    /**
     * 共有权人
     */
    @Column(value = "JOINNAME")
    private String JOINNAME;

    /**
     * 购买人
     */
    @Column(value = "PURCHASER")
    private String PURCHASER;

    /**
     * 购买价款
     */
    @Column(value = "BARGAINVALUE")
    private BigDecimal BARGAINVALUE;

    /**
     * 合同备案日期
     */
    @Column(value = "REGISTDATE")
    private Date REGISTDATE;

    /**
     * 签约日期
     */
    @Column(value = "BARGAINDATE")
    private Date BARGAINDATE;

    /**
     * 分户登记日期
     */
    @Column(value = "INSPECTDATE")
    private Date INSPECTDATE;

    /**
     * 门牌号
     */
    @Column(value = "MPH")
    private String MPH;

    @Column(value = "DIRECT_MODIFY")
    private String DIRECT_MODIFY;

    @Column(value = "TO_DEL")
    private String TO_DEL;

    /**
     * 层高
     */
    @Column(value = "CG")
    private String CG;

    /**
     * 在建工程标注位
     */
    @Column(value = "BY1")
    private String BY1;

    /**
     * 是否挂牌
     */
    @Column(value = "BY2")
    private String BY2;

    /**
     * 是否办理居间服务业务
     */
    @Column(value = "BY3")
    private Integer BY3;

    /**
     * 是否二手房签约
     */
    @Column(value = "BY4")
    private Integer BY4;

    /**
     * 开放式阳台个数
     */
    @Column(value = "KFSYT")
    private Integer KFSYT;

    /**
     * 封闭式阳台个数
     */
    @Column(value = "FBSYT")
    private Integer FBSYT;

    /**
     * 阳台面积
     */
    @Column(value = "YTMJ")
    private BigDecimal YTMJ;

    @Column(value = "SYN_FLAG")
    private Integer SYN_FLAG;

    @Column(value = "SYN_TIMESTAMP")
    private Date SYN_TIMESTAMP;

    @Column(value = "SYN_SEQNUM")
    private Integer SYN_SEQNUM;
}
